When we are talking about Cursors in Teradata SQL stored procedures, we refer to a pointer to a data record in the result set of an SQL query:
Cursors are used to iterate over a result set from one row to the next. They are a means to perform record oriented data processing in the context of set-oriented data processing implemented with SQL. Record-to record activity is usually the realm of a procedural language like C or C++.
When we talk about query result sets here, we refer to Teradata spool space holding the result set of a query at one particular point in time.
Cursors are used to iterate over a result set from one row to the next. They are a means to perform record oriented data processing in the context of set-oriented data processing implemented with SQL. Record-to record activity is usually the realm of a procedural language like C or C++.
When we talk about query result sets here, we refer to Teradata spool space holding the result set of a query at one particular point in time.
No comments:
Post a Comment